{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Cashflow","VAT calc"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cashflow","index":0,"n_rows":75,"n_cols":71,"rows_kept":75,"cut":false,"hidden":false,"merged":[[4,9,4,10],[71,3,72,38],[4,34,4,35],[3,64,3,65],[3,21,3,23],[4,18,4,19],[4,27,4,28],[0,3,0,18],[3,14,3,20],[74,3,74,38],[1,32,1,38],[3,48,3,49],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,12,4,13],[4,14,4,15],[4,16,4,17],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,30,4,31],[4,32,4,33]]}
[null,"Cashflow template",null,"A cashflow spreadsheet  is essential to show future anticipated peaks and troughs in the money coming into the business and the costs which the business will have to cover during that time. \nInput information into yellow cells. The boxes in grey will auto calculate for you."]
[]
[]
[null,null,"VAT%",{"$nulls":11},"Year beginning:",{"$nulls":6},"2019-04-01",{"$nulls":15},"Actual","Target",null,null,"VAT%",{"$nulls":4},"Year beginning",null,"2020-04-01",{"$nulls":8},"VAT%",{"$nulls":4},"Year beginning",null,"2021-04-01"]
[null,"INFLOWS",null,"2018-04-01",null,"2018-05-01",null,"2018-06-01",null,"1st Quarter Totals",null,null,"2018-07-01",null,"2018-08-01",null,"2018-09-01",null,"Half Year Totals",null,null,"2018-10-01",null,"2018-11-01",null,"2018-12-01",null,"9 month Totals",null,null,"2019-01-01",null,"2019-02-01",null,"2019-03-01",null,null,"Annual","Annual",null,{"$f":"$B5","v":"INFLOWS"},null,"Apr","May"," Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Annual",null,{"$f":"$B5","v":"INFLOWS"},null,"Apr","May"," Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Annual"]
[null,null,null,"Actual","Target","Actual","Target","Actual","Target","Actual","Target",null,"Actual","Target","Actual","Target","Actual","Target","Actual","Target",null,"Actual","Target","Actual","Target","Actual","Target","Actual","Target",null,"Actual","Target","Actual","Target","Actual","Target"]
[null,"Crop sales",0,{"$nulls":6},{"$f":"+D7+F7+H7","v":0},{"$f":"+E7+G7+I7","v":0},{"$nulls":7},{"$f":"+J7+M7+O7+Q7","v":0},{"$f":"+K7+N7+P7+R7","v":0},{"$nulls":7},{"$f":"+S7+V7+X7+Z7","v":0},{"$f":"+T7+W7+Y7+AA7","v":0},{"$nulls":8},{"$f":"+AB7+AE7+AG7+AI7","v":0},{"$f":"+AC7+AF7+AH7+AJ7","v":0},null,{"$f":"$B7","v":"Crop sales"},0,{"$nulls":12},{"$f":"SUM(AQ7:BB7)","v":0},null,{"$f":"$B7","v":"Crop sales"},0,{"$nulls":12},{"$f":"SUM(BG7:BR7)","v":0}]
[null,"Fodder sales",0,{"$nulls":6},{"$f":"+D8+F8+H8","v":0},{"$f":"+E8+G8+I8","v":0},{"$nulls":7},{"$f":"+J8+M8+O8+Q8","v":0},{"$f":"+K8+N8+P8+R8","v":0},{"$nulls":7},{"$f":"+S8+V8+X8+Z8","v":0},{"$f":"+T8+W8+Y8+AA8","v":0},{"$nulls":8},{"$f":"+AB8+AE8+AG8+AI8","v":0},{"$f":"+AC8+AF8+AH8+AJ8","v":0},null,"Fodder sales",0,{"$nulls":12},0,null,"Fodder sales",0,{"$nulls":12},0]
[null,"Dairy sales",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Dairy sales",0,{"$nulls":12},0,null,"Dairy sales",0,{"$nulls":12},0]
[null,"Livestock sales",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Livestock sales",0,{"$nulls":12},0,null,"Livestock sales",0,{"$nulls":12},0]
[null,"Income from other enterprises",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Income from other enterprises",0.2,{"$nulls":12},0,null,"Income from other enterprises",0.2,{"$nulls":12},0]
[null,"Short term rents ",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Short term rents ",0,{"$nulls":12},0,null,"Short term rents ",0,{"$nulls":12},0]
[null,"SFP ",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"SFP ",0,{"$nulls":12},0,null,"SFP ",0,{"$nulls":12},0]
[null,"Environmental schemes",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Environmental schemes",0,{"$nulls":12},0,null,"Environmental schemes",0,{"$nulls":12},0]
[null,"Sporting rents ",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Sporting rents ",0,{"$nulls":12},0,null,"Sporting rents ",0,{"$nulls":12},0]
[null,"Sundry income",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Sundry income",0.2,{"$nulls":12},0,null,"Sundry income",0.2,{"$nulls":12},0]
[null,"Wayleave",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Wayleave",0,{"$nulls":12},0,null,"Wayleave",0,{"$nulls":12},0]
[null,"Interest received",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Interest received",0,{"$nulls":12},0,null,"Interest received",0,{"$nulls":12},0]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"New loan capital",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"New loan capital",0,{"$nulls":12},{"$f":"SUM(AQ20:BB20)","v":0},null,"New loan capital",0,{"$nulls":12},{"$f":"SUM(BG20:BR20)","v":0}]
[null,"Private cash introduced",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Private cash introduced",0,{"$nulls":12},{"$f":"SUM(AQ21:BB21)","v":0},null,"Private cash introduced",0,{"$nulls":12},{"$f":"SUM(BG21:BR21)","v":0}]
[null,"Selling assets",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Selling assets",0.2,{"$nulls":12},{"$f":"SUM(AQ22:BB22)","v":0},null,"Selling assets",0.2,{"$nulls":12},{"$f":"SUM(BG22:BR22)","v":0}]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"VAT",null,null,null,{"$f":"-'VAT calc'!D70","v":0},{"$f":"-'VAT calc'!E70","v":0},{"$f":"-'VAT calc'!E70","v":0},{"$f":"-'VAT calc'!F70","v":0},0,0,null,{"$f":"-'VAT calc'!F70","v":0},{"$f":"-'VAT calc'!G70","v":0},{"$f":"-'VAT calc'!G70","v":0},{"$f":"-'VAT calc'!H70","v":0},{"$f":"-'VAT calc'!H70","v":0},{"$f":"-'VAT calc'!I70","v":0},0,0,null,{"$f":"-'VAT calc'!I70","v":0},{"$f":"-'VAT calc'!J70","v":0},{"$f":"-'VAT calc'!J70","v":0},{"$f":"-'VAT calc'!K70","v":0},{"$f":"-'VAT calc'!K70","v":0},{"$f":"-'VAT calc'!L70","v":0},0,0,null,{"$f":"-'VAT calc'!L70","v":0},{"$f":"-'VAT calc'!M70","v":0},{"$f":"-'VAT calc'!M70","v":0},{"$f":"-'VAT calc'!N70","v":0},{"$f":"-'VAT calc'!N70","v":0},{"$f":"-'VAT calc'!O70","v":0},null,0,0,null,{"$f":"$B24","v":"VAT"},null,{"$f":"-'VAT calc'!O70","v":0},{"$f":"-'VAT calc'!T70","v":0},{"$f":"-'VAT calc'!U70","v":0},{"$f":"-'VAT calc'!V70","v":0},{"$f":"-'VAT calc'!W70","v":0},{"$f":"-'VAT calc'!X70","v":0},{"$f":"-'VAT calc'!Y70","v":0},{"$f":"-'VAT calc'!Z70","v":0},{"$f":"-'VAT calc'!AA70","v":0},{"$f":"-'VAT calc'!AB70","v":0},{"$f":"-'VAT calc'!AC70","v":0},{"$f":"-'VAT calc'!AD70","v":0},null,null,{"$f":"$B24","v":"VAT"},null,{"$f":"-'VAT calc'!AE70","v":0},{"$f":"-'VAT calc'!AJ70","v":0},{"$f":"-'VAT calc'!AK70","v":0},{"$f":"-'VAT calc'!AL70","v":0},{"$f":"-'VAT calc'!AM70","v":0},{"$f":"-'VAT calc'!AN70","v":0},{"$f":"-'VAT calc'!AO70","v":0},{"$f":"-'VAT calc'!AP70","v":0},{"$f":"-'VAT calc'!AQ70","v":0},{"$f":"-'VAT calc'!AR70","v":0},{"$f":"-'VAT calc'!AS70","v":0},{"$f":"-'VAT calc'!AT70","v":0}]
[]
[null,"Total inflows",null,{"$f":"SUM(D7:D24)","v":0},{"$f":"SUM(E7:E24)","v":0},{"$f":"SUM(F7:F24)","v":0},0,0,0,0,0,null,0,{"$f":"SUM(N7:N24)","v":0},0,{"$f":"SUM(P7:P24)","v":0},0,{"$f":"SUM(R7:R24)","v":0},0,0,null,0,{"$f":"SUM(W7:W24)","v":0},0,{"$f":"SUM(Y7:Y24)","v":0},0,{"$f":"SUM(AA7:AA24)","v":0},0,0,null,0,{"$f":"SUM(AF7:AF24)","v":0},0,{"$f":"SUM(AH7:AH24)","v":0},0,{"$f":"SUM(AJ7:AJ24)","v":0},null,0,0,null,"Total inflows",null,{"$f":"SUM(AQ7:AQ24)","v":0},{"$f":"SUM(AR7:AR24)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Total inflows",null,{"$f":"SUM(BG7:BG24)","v":0},{"$f":"SUM(BH7:BH24)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"OUTFLOWS",{"$nulls":38},"OUTFLOWS",{"$nulls":15},"OUTFLOWS"]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Seeds and fertilisers",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Seeds and fertilisers",0,{"$nulls":12},{"$f":"SUM(AQ30:BB30)","v":0},null,"Seeds and fertilisers",0,{"$nulls":12},{"$f":"SUM(BG30:BR30)","v":0}]
[null,"Chemicals and sundry crop costs",0,{"$nulls":6},{"$f":"+D31+F31+H31","v":0},{"$f":"+E31+G31+I31","v":0},{"$nulls":7},{"$f":"+J31+M31+O31+Q31","v":0},{"$f":"+K31+N31+P31+R31","v":0},{"$nulls":7},{"$f":"+S31+V31+X31+Z31","v":0},{"$f":"+T31+W31+Y31+AA31","v":0},{"$nulls":8},{"$f":"+AB31+AE31+AG31+AI31","v":0},{"$f":"+AC31+AF31+AH31+AJ31","v":0},null,"Chemicals and sundry crop costs",0,{"$nulls":12},0,null,"Chemicals and sundry crop costs",0,{"$nulls":12},0]
[null,"Feedstuffs",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Feedstuffs",0,{"$nulls":12},0,null,"Feedstuffs",0,{"$nulls":12},0]
[null,"Purchased fodder",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Purchased fodder",0,{"$nulls":12},0,null,"Purchased fodder",0,{"$nulls":12},0]
[null,"Livestock",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Livestock",0,{"$nulls":12},0,null,"Livestock",0,{"$nulls":12},0]
[null,"Vet, medical and sundry livestock costs",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Vet, medical and sundry livestock costs",0,{"$nulls":12},0,null,"Vet, medical and sundry livestock costs",0,{"$nulls":12},0]
[{"$nulls":40},0,{"$nulls":15},0]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Power and machinery",{"$nulls":38},"Power and machinery",{"$nulls":15},"Power and machinery"]
[null,"Repairs and spares",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Repairs and spares",0.2,{"$nulls":12},{"$f":"SUM(AQ39:BB39)","v":0},null,"Repairs and spares",0.2,{"$nulls":12},{"$f":"SUM(BG39:BR39)","v":0}]
[null,"Fuel and oil",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Fuel and oil",0.2,{"$nulls":12},{"$f":"SUM(AQ40:BB40)","v":0},null,"Fuel and oil",0.2,{"$nulls":12},{"$f":"SUM(BG40:BR40)","v":0}]
[null,"Electricity",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Electricity",0.2,{"$nulls":12},{"$f":"SUM(AQ41:BB41)","v":0},null,"Electricity",0.2,{"$nulls":12},{"$f":"SUM(BG41:BR41)","v":0}]
[null,"Vehicle tax and insurance",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Vehicle tax and insurance",0.2,{"$nulls":12},{"$f":"SUM(AQ42:BB42)","v":0},null,"Vehicle tax and insurance",0.2,{"$nulls":12},{"$f":"SUM(BG42:BR42)","v":0}]
[null,"Contractors ",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Contractors ",0.2,{"$nulls":12},{"$f":"SUM(AQ43:BB43)","v":0},null,"Contractors ",0.2,{"$nulls":12},{"$f":"SUM(BG43:BR43)","v":0}]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Sundry overheads",{"$nulls":38},"Sundry overheads",{"$nulls":15},"Sundry overheads"]
[null,"Water",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Water",0,{"$nulls":14},"Water",0]
[null,"General insurance",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"General insurance",0,{"$nulls":12},{"$f":"SUM(AQ47:BB47)","v":0},null,"General insurance",0,{"$nulls":12},{"$f":"SUM(BG47:BR47)","v":0}]
[null,"Office costs",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Office costs",0.2,{"$nulls":12},0,null,"Office costs",0.2,{"$nulls":12},0]
[null,"Miscellaneous costs",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Miscellaneous costs",0.2,{"$nulls":12},0,null,"Miscellaneous costs",0.2,{"$nulls":12},0]
[null,"Council tax",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Council tax",0,{"$nulls":12},0,null,"Council tax",0,{"$nulls":12},0]
[null,"Advice and professional fees",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Advice and professional fees",0.2,{"$nulls":12},0,null,"Advice and professional fees",0.2,{"$nulls":12},0]
[null,"Repairs/maintenance on land and buildings",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Repairs/maintenance on land and buildings",0.2,{"$nulls":12},0,null,"Repairs/maintenance on land and buildings",0.2,{"$nulls":12},0]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Rent ",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Rent ",0,{"$nulls":12},{"$f":"SUM(AQ54:BB54)","v":0},null,"Rent ",0,{"$nulls":12},{"$f":"SUM(BG54:BR54)","v":0}]
[null,"Paid labour",0,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Paid labour",0,{"$nulls":12},{"$f":"SUM(AQ55:BB55)","v":0},null,"Paid labour",0,{"$nulls":12},{"$f":"SUM(BG55:BR55)","v":0}]
[null,"Other cash purchase",0.2,{"$nulls":6},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Other cash purchase",0.2,{"$nulls":12},{"$f":"SUM(AQ56:BB56)","v":0},null,"Other cash purchase",0.2,{"$nulls":12},{"$f":"SUM(BG56:BR56)","v":0}]
[null,"Bank charges",0,{"$nulls":6},{"$f":"+D57+F57+H57","v":0},{"$f":"+E57+G57+I57","v":0},{"$nulls":7},{"$f":"+J57+M57+O57+Q57","v":0},{"$f":"+K57+N57+P57+R57","v":0},{"$nulls":7},{"$f":"+S57+V57+X57+Z57","v":0},{"$f":"+T57+W57+Y57+AA57","v":0},{"$nulls":8},{"$f":"+AB57+AE57+AG57+AI57","v":0},{"$f":"+AC57+AF57+AH57+AJ57","v":0},null,"Bank charges",0,{"$nulls":12},{"$f":"SUM(AQ57:BB57)","v":0},null,"Bank charges",0,{"$nulls":12},{"$f":"SUM(BG57:BR57)","v":0}]
[{"$nulls":40},{"$f":"$B58","v":0},{"$nulls":15},{"$f":"$B58","v":0}]
[]
[null,"Drawings",{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Drawings",{"$nulls":13},{"$f":"SUM(AQ60:BB60)","v":0},null,"Drawings",{"$nulls":13},{"$f":"SUM(BG60:BR60)","v":0}]
[null,"Tax",{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Tax",{"$nulls":13},{"$f":"SUM(AQ61:BB61)","v":0},null,"Tax",{"$nulls":13},{"$f":"SUM(BG61:BR61)","v":0}]
[null,"Asset purchases",{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Asset purchases",{"$nulls":13},{"$f":"SUM(AQ62:BB62)","v":0},null,"Asset purchases",{"$nulls":13},{"$f":"SUM(BG62:BR62)","v":0}]
[null,"Capital repayments",{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Capital repayments",{"$nulls":13},{"$f":"SUM(AQ63:BB63)","v":0},null,"Capital repayments",{"$nulls":13},{"$f":"SUM(BG63:BR63)","v":0}]
[null,"Interest payments",{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":7},0,0,{"$nulls":8},0,0,null,"Interest payments",{"$nulls":13},{"$f":"SUM(AQ64:BB64)","v":0},null,"Interest payments",{"$nulls":13},{"$f":"SUM(BG64:BR64)","v":0}]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Total outflows",null,{"$f":"SUM(D30:D64)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(M30:M64)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(V30:V64)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(AE30:AE64)","v":0},0,0,0,0,0,null,0,0,null,"Total outflows",null,{"$f":"SUM(AQ30:AQ64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,"Total outflows",null,{"$f":"SUM(BG30:BG64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":40},0,{"$nulls":15},0]
[null,"Opening balance",null,null,null,{"$f":"D70","v":0},0,0,0,null,null,null,{"$f":"H70","v":0},{"$f":"I70","v":0},0,0,0,0,null,null,null,{"$f":"Q70","v":0},{"$f":"R70","v":0},0,0,0,0,null,null,null,{"$f":"Z70","v":0},{"$f":"AA70","v":0},0,0,{"$f":"AG70","v":0},0,{"$nulls":4},"Opening balance",null,{"$f":"AI70","v":0},{"$f":"AQ70","v":0},{"$f":"AR70","v":0},0,0,0,0,0,0,0,0,0,null,null,"Opening balance",null,{"$f":"BB70","v":0},{"$f":"BG70","v":0},{"$f":"BH70","v":0},0,0,0,0,0,0,0,0,0]
[null,"Movement",null,{"$f":"D26-D66","v":0},0,0,0,0,0,null,null,null,{"$f":"M26-M66","v":0},0,0,0,0,0,null,null,null,{"$f":"V26-V66","v":0},0,0,0,0,0,null,null,null,{"$f":"AE26-AE66","v":0},{"$f":"AF26-AF66","v":0},{"$f":"AG26-AG66","v":0},{"$f":"AH26-AH66","v":0},{"$f":"AI26-AS66","v":0},{"$f":"AJ26-AT66","v":0},{"$nulls":4},"Movement",null,{"$f":"AQ26-AW66","v":0},{"$f":"AR26-AR66","v":0},0,0,0,0,0,0,0,0,0,0,null,null,"Movement",null,{"$f":"BG26-BM66","v":0},{"$f":"BH26-BH66","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Closing balance",null,{"$f":"D68+D69","v":0},0,0,0,0,0,null,null,null,{"$f":"M68+M69","v":0},{"$f":"N68+N69","v":0},0,{"$f":"P68+P69","v":0},0,{"$f":"R68+R69","v":0},null,null,null,0,{"$f":"W68+W69","v":0},0,{"$f":"Y68+Y69","v":0},0,{"$f":"AA68+AA69","v":0},null,null,null,0,{"$f":"AF68+AF69","v":0},0,{"$f":"AH68+AH69","v":0},0,{"$f":"AJ68+AJ69","v":0},{"$nulls":4},"Closing balance",null,0,0,0,0,0,0,{"$f":"AW68+AW69","v":0},0,{"$f":"AY68+AY69","v":0},0,0,0,null,null,"Closing balance",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"© Agriculture and Horticulture Development Board 2019. All rights reserved. While the Agriculture and Horticulture Development Board,  operating through its AHDB Dairy division, seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law, the Agriculture and Horticulture Development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document."]
[]
[]
[null,null,null,"Additional items of income or expenditure can be added by right clicking on any number on the vertical axis and selecting insert, you will then be able to type in the new item and it's value across the cashflow. It is wise to ensure this new item is being tallied into the Annual figure in the right hand column and this can be done by clicking on the relevant box in the Annual column, click on the AutoSum (in the Home tab above), then highlight the corresponding row for the new item you have added across all the months (they will then be outlined with a blue, dashed box) and press return. This will need to be done with all the years.      "]

{"sheet":"VAT calc","index":1,"n_rows":70,"n_cols":47,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,9,5,10],[5,25,5,26],[5,41,5,42],[1,13,1,16],[0,1,0,6]]}
[null,"VAT calculator"]
[]
[]
[null,"Values have been taken from the Cashflow page and will carry across automatically from the Actual columns (not Target)."]
[]
[null,null,"VAT%",{"$nulls":4},"Year beginning",null,{"$f":"Cashflow!V4","v":"2019-04-01"},{"$nulls":8},"VAT%",{"$nulls":4},"Year beginning",null,{"$f":"Cashflow!AW4","v":"2020-04-01"},{"$nulls":8},"VAT%",{"$nulls":4},"Year beginning",null,{"$f":"Cashflow!BM4","v":"2021-04-01"}]
[null,{"$f":"Cashflow!B5","v":"INFLOWS"},null,"Apr","May"," Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar",null,null,{"$f":"$B7","v":"INFLOWS"},null,"Apr","May"," Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar",null,null,{"$f":"$B7","v":"INFLOWS"},null,"Apr","May"," Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar"]
[null,{"$f":"Cashflow!B7","v":"Crop sales"},{"$f":"Cashflow!C7","v":0},{"$f":"ROUND((100*$C8*Cashflow!D7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!F7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!H7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!M7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!O7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!Q7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!V7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!X7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!Z7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!AE7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!AG7)/(100+(100*$C8)),0)","v":0},{"$f":"ROUND((100*$C8*Cashflow!AI7)/(100+(100*$C8)),0)","v":0},null,null,{"$f":"$B8","v":"Crop sales"},{"$f":"Cashflow!AP7","v":0},{"$f":"ROUND((100*$S8*Cashflow!AQ7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AR7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AS7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AT7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AU7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AV7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AW7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AX7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AY7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!AZ7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!BA7)/(100+(100*$S8)),0)","v":0},{"$f":"ROUND((100*$S8*Cashflow!BB7)/(100+(100*$S8)),0)","v":0},null,null,{"$f":"$B8","v":"Crop sales"},{"$f":"Cashflow!BF7","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BG7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BH7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BI7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BJ7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BK7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BL7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BM7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BN7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BO7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BP7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BQ7)/(100+(100*$AI8)),0)","v":0},{"$f":"ROUND((100*$AI8*Cashflow!BR7)/(100+(100*$AI8)),0)","v":0}]
[null,{"$f":"Cashflow!B8","v":"Fodder sales"},{"$f":"Cashflow!C8","v":0},{"$f":"ROUND((100*$C9*Cashflow!D8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!F8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!H8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!M8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!O8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!Q8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!V8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!X8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!Z8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!AE8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!AG8)/(100+(100*$C9)),0)","v":0},{"$f":"ROUND((100*$C9*Cashflow!AI8)/(100+(100*$C9)),0)","v":0},null,null,"Fodder sales",{"$f":"Cashflow!AP8","v":0},{"$f":"ROUND((100*$S9*Cashflow!AQ8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AR8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AS8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AT8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AU8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AV8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AW8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AX8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AY8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!AZ8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!BA8)/(100+(100*$S9)),0)","v":0},{"$f":"ROUND((100*$S9*Cashflow!BB8)/(100+(100*$S9)),0)","v":0},null,null,"Fodder sales",{"$f":"Cashflow!BF8","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BG8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BH8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BI8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BJ8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BK8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BL8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BM8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BN8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BO8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BP8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BQ8)/(100+(100*$AI9)),0)","v":0},{"$f":"ROUND((100*$AI9*Cashflow!BR8)/(100+(100*$AI9)),0)","v":0}]
[null,{"$f":"Cashflow!B9","v":"Dairy sales"},{"$f":"Cashflow!C9","v":0},{"$f":"ROUND((100*$C10*Cashflow!D9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!F9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!H9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!M9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!O9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!Q9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!V9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!X9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!Z9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!AE9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!AG9)/(100+(100*$C10)),0)","v":0},{"$f":"ROUND((100*$C10*Cashflow!AI9)/(100+(100*$C10)),0)","v":0},null,null,"Dairy sales",{"$f":"Cashflow!AP9","v":0},{"$f":"ROUND((100*$S10*Cashflow!AQ9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AR9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AS9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AT9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AU9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AV9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AW9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AX9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AY9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!AZ9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!BA9)/(100+(100*$S10)),0)","v":0},{"$f":"ROUND((100*$S10*Cashflow!BB9)/(100+(100*$S10)),0)","v":0},null,null,"Dairy sales",{"$f":"Cashflow!BF9","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BG9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BH9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BI9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BJ9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BK9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BL9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BM9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BN9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BO9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BP9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BQ9)/(100+(100*$AI10)),0)","v":0},{"$f":"ROUND((100*$AI10*Cashflow!BR9)/(100+(100*$AI10)),0)","v":0}]
[null,{"$f":"Cashflow!B10","v":"Livestock sales"},{"$f":"Cashflow!C10","v":0},{"$f":"ROUND((100*$C11*Cashflow!D10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!F10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!H10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!M10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!O10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!Q10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!V10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!X10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!Z10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!AE10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!AG10)/(100+(100*$C11)),0)","v":0},{"$f":"ROUND((100*$C11*Cashflow!AI10)/(100+(100*$C11)),0)","v":0},null,null,"Livestock sales",{"$f":"Cashflow!AP10","v":0},{"$f":"ROUND((100*$S11*Cashflow!AQ10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AR10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AS10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AT10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AU10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AV10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AW10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AX10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AY10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!AZ10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!BA10)/(100+(100*$S11)),0)","v":0},{"$f":"ROUND((100*$S11*Cashflow!BB10)/(100+(100*$S11)),0)","v":0},null,null,"Livestock sales",{"$f":"Cashflow!BF10","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BG10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BH10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BI10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BJ10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BK10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BL10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BM10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BN10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BO10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BP10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BQ10)/(100+(100*$AI11)),0)","v":0},{"$f":"ROUND((100*$AI11*Cashflow!BR10)/(100+(100*$AI11)),0)","v":0}]
[null,{"$f":"Cashflow!B11","v":"Income from other enterprises"},{"$f":"Cashflow!C11","v":0.2},{"$f":"ROUND((100*$C12*Cashflow!D11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!F11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!H11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!M11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!O11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!Q11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!V11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!X11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!Z11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!AE11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!AG11)/(100+(100*$C12)),0)","v":0},{"$f":"ROUND((100*$C12*Cashflow!AI11)/(100+(100*$C12)),0)","v":0},null,null,"Income from other enterprises",{"$f":"Cashflow!AP11","v":0.2},{"$f":"ROUND((100*$S12*Cashflow!AQ11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AR11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AS11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AT11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AU11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AV11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AW11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AX11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AY11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!AZ11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!BA11)/(100+(100*$S12)),0)","v":0},{"$f":"ROUND((100*$S12*Cashflow!BB11)/(100+(100*$S12)),0)","v":0},null,null,"Income from other enterprises",{"$f":"Cashflow!BF11","v":0.2},{"$f":"ROUND((100*$AI12*Cashflow!BG11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BH11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BI11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BJ11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BK11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BL11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BM11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BN11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BO11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BP11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BQ11)/(100+(100*$AI12)),0)","v":0},{"$f":"ROUND((100*$AI12*Cashflow!BR11)/(100+(100*$AI12)),0)","v":0}]
[null,{"$f":"Cashflow!B12","v":"Short term rents "},{"$f":"Cashflow!C12","v":0},{"$f":"ROUND((100*$C13*Cashflow!D12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!F12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!H12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!M12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!O12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!Q12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!V12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!X12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!Z12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!AE12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!AG12)/(100+(100*$C13)),0)","v":0},{"$f":"ROUND((100*$C13*Cashflow!AI12)/(100+(100*$C13)),0)","v":0},null,null,"Short term rents ",{"$f":"Cashflow!AP12","v":0},{"$f":"ROUND((100*$S13*Cashflow!AQ12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AR12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AS12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AT12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AU12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AV12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AW12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AX12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AY12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!AZ12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!BA12)/(100+(100*$S13)),0)","v":0},{"$f":"ROUND((100*$S13*Cashflow!BB12)/(100+(100*$S13)),0)","v":0},null,null,"Short term rents ",{"$f":"Cashflow!BF12","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BG12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BH12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BI12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BJ12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BK12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BL12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BM12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BN12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BO12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BP12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BQ12)/(100+(100*$AI13)),0)","v":0},{"$f":"ROUND((100*$AI13*Cashflow!BR12)/(100+(100*$AI13)),0)","v":0}]
[null,{"$f":"Cashflow!B13","v":"SFP "},{"$f":"Cashflow!C13","v":0},{"$f":"ROUND((100*$C14*Cashflow!D13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!F13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!H13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!M13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!O13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!Q13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!V13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!X13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!Z13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!AE13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!AG13)/(100+(100*$C14)),0)","v":0},{"$f":"ROUND((100*$C14*Cashflow!AI13)/(100+(100*$C14)),0)","v":0},null,null,"SFP ",{"$f":"Cashflow!AP13","v":0},{"$f":"ROUND((100*$S14*Cashflow!AQ13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AR13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AS13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AT13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AU13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AV13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AW13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AX13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AY13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!AZ13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!BA13)/(100+(100*$S14)),0)","v":0},{"$f":"ROUND((100*$S14*Cashflow!BB13)/(100+(100*$S14)),0)","v":0},null,null,"SFP ",{"$f":"Cashflow!BF13","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BG13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BH13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BI13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BJ13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BK13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BL13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BM13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BN13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BO13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BP13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BQ13)/(100+(100*$AI14)),0)","v":0},{"$f":"ROUND((100*$AI14*Cashflow!BR13)/(100+(100*$AI14)),0)","v":0}]
[null,{"$f":"Cashflow!B14","v":"Environmental schemes"},{"$f":"Cashflow!C14","v":0},{"$f":"ROUND((100*$C15*Cashflow!D14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!F14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!H14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!M14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!O14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!Q14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!V14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!X14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!Z14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!AE14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!AG14)/(100+(100*$C15)),0)","v":0},{"$f":"ROUND((100*$C15*Cashflow!AI14)/(100+(100*$C15)),0)","v":0},null,null,"Environmental schemes",{"$f":"Cashflow!AP14","v":0},{"$f":"ROUND((100*$S15*Cashflow!AQ14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AR14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AS14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AT14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AU14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AV14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AW14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AX14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AY14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!AZ14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!BA14)/(100+(100*$S15)),0)","v":0},{"$f":"ROUND((100*$S15*Cashflow!BB14)/(100+(100*$S15)),0)","v":0},null,null,"Environmental schemes",{"$f":"Cashflow!BF14","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BG14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BH14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BI14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BJ14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BK14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BL14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BM14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BN14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BO14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BP14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BQ14)/(100+(100*$AI15)),0)","v":0},{"$f":"ROUND((100*$AI15*Cashflow!BR14)/(100+(100*$AI15)),0)","v":0}]
[null,{"$f":"Cashflow!B15","v":"Sporting rents "},{"$f":"Cashflow!C15","v":0},{"$f":"ROUND((100*$C16*Cashflow!D15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!F15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!H15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!M15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!O15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!Q15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!V15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!X15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!Z15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!AE15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!AG15)/(100+(100*$C16)),0)","v":0},{"$f":"ROUND((100*$C16*Cashflow!AI15)/(100+(100*$C16)),0)","v":0},null,null,"Sporting rents ",{"$f":"Cashflow!AP15","v":0},{"$f":"ROUND((100*$S16*Cashflow!AQ15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AR15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AS15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AT15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AU15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AV15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AW15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AX15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AY15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!AZ15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!BA15)/(100+(100*$S16)),0)","v":0},{"$f":"ROUND((100*$S16*Cashflow!BB15)/(100+(100*$S16)),0)","v":0},null,null,"Sporting rents ",{"$f":"Cashflow!BF15","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BG15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BH15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BI15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BJ15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BK15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BL15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BM15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BN15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BO15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BP15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BQ15)/(100+(100*$AI16)),0)","v":0},{"$f":"ROUND((100*$AI16*Cashflow!BR15)/(100+(100*$AI16)),0)","v":0}]
[null,{"$f":"Cashflow!B16","v":"Sundry income"},{"$f":"Cashflow!C16","v":0.2},{"$f":"ROUND((100*$C17*Cashflow!D16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!F16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!H16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!M16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!O16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!Q16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!V16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!X16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!Z16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!AE16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!AG16)/(100+(100*$C17)),0)","v":0},{"$f":"ROUND((100*$C17*Cashflow!AI16)/(100+(100*$C17)),0)","v":0},null,null,"Sundry income",{"$f":"Cashflow!AP16","v":0.2},{"$f":"ROUND((100*$S17*Cashflow!AQ16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AR16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AS16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AT16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AU16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AV16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AW16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AX16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AY16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!AZ16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!BA16)/(100+(100*$S17)),0)","v":0},{"$f":"ROUND((100*$S17*Cashflow!BB16)/(100+(100*$S17)),0)","v":0},null,null,"Sundry income",{"$f":"Cashflow!BF16","v":0.2},{"$f":"ROUND((100*$AI17*Cashflow!BG16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BH16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BI16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BJ16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BK16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BL16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BM16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BN16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BO16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BP16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BQ16)/(100+(100*$AI17)),0)","v":0},{"$f":"ROUND((100*$AI17*Cashflow!BR16)/(100+(100*$AI17)),0)","v":0}]
[null,{"$f":"Cashflow!B17","v":"Wayleave"},{"$f":"Cashflow!C17","v":0},{"$f":"ROUND((100*$C18*Cashflow!D17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!F17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!H17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!M17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!O17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!Q17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!V17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!X17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!Z17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!AE17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!AG17)/(100+(100*$C18)),0)","v":0},{"$f":"ROUND((100*$C18*Cashflow!AI17)/(100+(100*$C18)),0)","v":0},null,null,"Wayleave",{"$f":"Cashflow!AP17","v":0},{"$f":"ROUND((100*$S18*Cashflow!AQ17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AR17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AS17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AT17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AU17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AV17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AW17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AX17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AY17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!AZ17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!BA17)/(100+(100*$S18)),0)","v":0},{"$f":"ROUND((100*$S18*Cashflow!BB17)/(100+(100*$S18)),0)","v":0},null,null,"Wayleave",{"$f":"Cashflow!BF17","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BG17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BH17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BI17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BJ17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BK17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BL17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BM17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BN17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BO17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BP17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BQ17)/(100+(100*$AI18)),0)","v":0},{"$f":"ROUND((100*$AI18*Cashflow!BR17)/(100+(100*$AI18)),0)","v":0}]
[null,{"$f":"Cashflow!B18","v":"Interest received"},{"$f":"Cashflow!C18","v":0},{"$f":"ROUND((100*$C19*Cashflow!D18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!F18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!H18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!M18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!O18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!Q18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!V18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!X18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!Z18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!AE18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!AG18)/(100+(100*$C19)),0)","v":0},{"$f":"ROUND((100*$C19*Cashflow!AI18)/(100+(100*$C19)),0)","v":0},null,null,"Interest received",{"$f":"Cashflow!AP18","v":0},{"$f":"ROUND((100*$S19*Cashflow!AQ18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AR18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AS18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AT18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AU18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AV18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AW18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AX18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AY18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!AZ18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!BA18)/(100+(100*$S19)),0)","v":0},{"$f":"ROUND((100*$S19*Cashflow!BB18)/(100+(100*$S19)),0)","v":0},null,null,"Interest received",{"$f":"Cashflow!BF18","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BG18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BH18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BI18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BJ18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BK18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BL18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BM18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BN18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BO18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BP18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BQ18)/(100+(100*$AI19)),0)","v":0},{"$f":"ROUND((100*$AI19*Cashflow!BR18)/(100+(100*$AI19)),0)","v":0}]
[null,{"$f":"Cashflow!B19","v":0},{"$f":"Cashflow!C19","v":0},{"$f":"ROUND((100*$C20*Cashflow!D19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!F19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!H19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!M19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!O19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!Q19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!V19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!X19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!Z19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!AE19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!AG19)/(100+(100*$C20)),0)","v":0},{"$f":"ROUND((100*$C20*Cashflow!AI19)/(100+(100*$C20)),0)","v":0},null,null,0,{"$f":"Cashflow!AP19","v":0},{"$f":"ROUND((100*$S20*Cashflow!AQ19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AR19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AS19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AT19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AU19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AV19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AW19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AX19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AY19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!AZ19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!BA19)/(100+(100*$S20)),0)","v":0},{"$f":"ROUND((100*$S20*Cashflow!BB19)/(100+(100*$S20)),0)","v":0},null,null,0,{"$f":"Cashflow!BF19","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BG19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BH19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BI19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BJ19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BK19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BL19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BM19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BN19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BO19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BP19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BQ19)/(100+(100*$AI20)),0)","v":0},{"$f":"ROUND((100*$AI20*Cashflow!BR19)/(100+(100*$AI20)),0)","v":0}]
[null,{"$f":"Cashflow!B20","v":"New loan capital"},{"$f":"Cashflow!C20","v":0},{"$f":"ROUND((100*$C21*Cashflow!D20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!F20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!H20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!M20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!O20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!Q20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!V20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!X20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!Z20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!AE20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!AG20)/(100+(100*$C21)),0)","v":0},{"$f":"ROUND((100*$C21*Cashflow!AI20)/(100+(100*$C21)),0)","v":0},null,null,"New loan capital",{"$f":"Cashflow!AP20","v":0},{"$f":"ROUND((100*$S21*Cashflow!AQ20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AR20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AS20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AT20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AU20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AV20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AW20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AX20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AY20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!AZ20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!BA20)/(100+(100*$S21)),0)","v":0},{"$f":"ROUND((100*$S21*Cashflow!BB20)/(100+(100*$S21)),0)","v":0},null,null,"New loan capital",{"$f":"Cashflow!BF20","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BG20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BH20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BI20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BJ20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BK20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BL20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BM20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BN20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BO20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BP20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BQ20)/(100+(100*$AI21)),0)","v":0},{"$f":"ROUND((100*$AI21*Cashflow!BR20)/(100+(100*$AI21)),0)","v":0}]
[null,{"$f":"Cashflow!B21","v":"Private cash introduced"},{"$f":"Cashflow!C21","v":0},{"$f":"ROUND((100*$C22*Cashflow!D21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!F21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!H21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!M21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!O21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!Q21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!V21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!X21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!Z21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!AE21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!AG21)/(100+(100*$C22)),0)","v":0},{"$f":"ROUND((100*$C22*Cashflow!AI21)/(100+(100*$C22)),0)","v":0},null,null,"Private cash introduced",{"$f":"Cashflow!AP21","v":0},{"$f":"ROUND((100*$S22*Cashflow!AQ21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AR21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AS21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AT21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AU21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AV21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AW21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AX21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AY21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!AZ21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!BA21)/(100+(100*$S22)),0)","v":0},{"$f":"ROUND((100*$S22*Cashflow!BB21)/(100+(100*$S22)),0)","v":0},null,null,"Private cash introduced",{"$f":"Cashflow!BF21","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BG21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BH21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BI21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BJ21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BK21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BL21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BM21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BN21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BO21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BP21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BQ21)/(100+(100*$AI22)),0)","v":0},{"$f":"ROUND((100*$AI22*Cashflow!BR21)/(100+(100*$AI22)),0)","v":0}]
[null,{"$f":"Cashflow!B22","v":"Selling assets"},{"$f":"Cashflow!C22","v":0.2},{"$f":"ROUND((100*$C23*Cashflow!D22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!F22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!H22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!M22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!O22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!Q22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!V22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!X22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!Z22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!AE22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!AG22)/(100+(100*$C23)),0)","v":0},{"$f":"ROUND((100*$C23*Cashflow!AI22)/(100+(100*$C23)),0)","v":0},null,null,"Selling assets",{"$f":"Cashflow!AP22","v":0.2},{"$f":"ROUND((100*$S23*Cashflow!AQ22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AR22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AS22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AT22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AU22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AV22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AW22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AX22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AY22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!AZ22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!BA22)/(100+(100*$S23)),0)","v":0},{"$f":"ROUND((100*$S23*Cashflow!BB22)/(100+(100*$S23)),0)","v":0},null,null,"Selling assets",{"$f":"Cashflow!BF22","v":0.2},{"$f":"ROUND((100*$AI23*Cashflow!BG22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BH22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BI22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BJ22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BK22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BL22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BM22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BN22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BO22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BP22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BQ22)/(100+(100*$AI23)),0)","v":0},{"$f":"ROUND((100*$AI23*Cashflow!BR22)/(100+(100*$AI23)),0)","v":0}]
[null,{"$f":"Cashflow!B23","v":0},{"$f":"Cashflow!C23","v":0},{"$f":"ROUND((100*$C24*Cashflow!D23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!F23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!H23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!M23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!O23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!Q23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!V23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!X23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!Z23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!AE23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!AG23)/(100+(100*$C24)),0)","v":0},{"$f":"ROUND((100*$C24*Cashflow!AI23)/(100+(100*$C24)),0)","v":0},null,null,0,{"$f":"Cashflow!AP23","v":0},{"$f":"ROUND((100*$S24*Cashflow!AQ23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AR23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AS23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AT23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AU23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AV23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AW23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AX23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AY23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!AZ23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!BA23)/(100+(100*$S24)),0)","v":0},{"$f":"ROUND((100*$S24*Cashflow!BB23)/(100+(100*$S24)),0)","v":0},null,null,0,{"$f":"Cashflow!BF23","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BG23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BH23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BI23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BJ23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BK23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BL23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BM23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BN23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BO23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BP23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BQ23)/(100+(100*$AI24)),0)","v":0},{"$f":"ROUND((100*$AI24*Cashflow!BR23)/(100+(100*$AI24)),0)","v":0}]
[null,{"$f":"Cashflow!B24","v":"VAT"},{"$f":"Cashflow!C24","v":0},{"$nulls":14},{"$f":"$B25","v":"VAT"},{"$f":"Cashflow!AP24","v":0},{"$nulls":14},{"$f":"$B25","v":"VAT"},{"$f":"Cashflow!BF24","v":0}]
[null,{"$f":"Cashflow!B25","v":0},{"$f":"Cashflow!C25","v":0},{"$nulls":15},{"$f":"Cashflow!AP25","v":0},{"$nulls":15},{"$f":"Cashflow!BF25","v":0}]
[null,{"$f":"Cashflow!B26","v":"Total inflows"},{"$f":"Cashflow!C26","v":0},{"$f":"SUM(D8:D25)","v":0},{"$f":"SUM(E8:E25)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,"Total inflows",{"$f":"Cashflow!AP26","v":0},{"$f":"SUM(T8:T25)","v":0},{"$f":"SUM(U8:U25)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,"Total inflows",{"$f":"Cashflow!BF26","v":0},{"$f":"SUM(AJ8:AJ25)","v":0},{"$f":"SUM(AK8:AK25)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Cashflow!B27","v":0},{"$f":"Cashflow!C27","v":0},{"$nulls":14},0,{"$f":"Cashflow!AP27","v":0},{"$nulls":14},0,{"$f":"Cashflow!BF27","v":0}]
[null,{"$f":"Cashflow!B28","v":"OUTFLOWS"},{"$f":"Cashflow!C28","v":0},{"$nulls":14},"OUTFLOWS",{"$f":"Cashflow!AP28","v":0},{"$nulls":14},"OUTFLOWS",{"$f":"Cashflow!BF28","v":0}]
[null,{"$f":"Cashflow!B29","v":0},{"$f":"Cashflow!C29","v":0},{"$f":"ROUND((100*$C30*Cashflow!D29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!F29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!H29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!M29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!O29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!Q29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!V29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!X29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!Z29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!AE29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!AG29)/(100+(100*$C30)),0)","v":0},{"$f":"ROUND((100*$C30*Cashflow!AI29)/(100+(100*$C30)),0)","v":0},null,null,0,{"$f":"Cashflow!AP29","v":0},{"$f":"ROUND((100*$S30*Cashflow!AQ29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AR29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AS29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AT29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AU29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AV29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AW29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AX29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AY29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!AZ29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!BA29)/(100+(100*$S30)),0)","v":0},{"$f":"ROUND((100*$S30*Cashflow!BB29)/(100+(100*$S30)),0)","v":0},null,null,0,{"$f":"Cashflow!BF29","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BG29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BH29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BI29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BJ29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BK29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BL29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BM29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BN29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BO29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BP29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BQ29)/(100+(100*$AI30)),0)","v":0},{"$f":"ROUND((100*$AI30*Cashflow!BR29)/(100+(100*$AI30)),0)","v":0}]
[null,{"$f":"Cashflow!B30","v":"Seeds and fertilisers"},{"$f":"Cashflow!C30","v":0},{"$f":"ROUND((100*$C31*Cashflow!D30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!F30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!H30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!M30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!O30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!Q30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!V30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!X30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!Z30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!AE30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!AG30)/(100+(100*$C31)),0)","v":0},{"$f":"ROUND((100*$C31*Cashflow!AI30)/(100+(100*$C31)),0)","v":0},null,null,"Seeds and fertilisers",{"$f":"Cashflow!AP30","v":0},{"$f":"ROUND((100*$S31*Cashflow!AQ30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AR30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AS30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AT30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AU30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AV30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AW30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AX30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AY30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!AZ30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!BA30)/(100+(100*$S31)),0)","v":0},{"$f":"ROUND((100*$S31*Cashflow!BB30)/(100+(100*$S31)),0)","v":0},null,null,"Seeds and fertilisers",{"$f":"Cashflow!BF30","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BG30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BH30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BI30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BJ30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BK30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BL30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BM30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BN30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BO30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BP30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BQ30)/(100+(100*$AI31)),0)","v":0},{"$f":"ROUND((100*$AI31*Cashflow!BR30)/(100+(100*$AI31)),0)","v":0}]
[null,{"$f":"Cashflow!B31","v":"Chemicals and sundry crop costs"},{"$f":"Cashflow!C31","v":0},{"$f":"ROUND((100*$C32*Cashflow!D31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!F31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!H31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!M31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!O31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!Q31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!V31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!X31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!Z31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!AE31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!AG31)/(100+(100*$C32)),0)","v":0},{"$f":"ROUND((100*$C32*Cashflow!AI31)/(100+(100*$C32)),0)","v":0},null,null,"Chemicals and sundry crop costs",{"$f":"Cashflow!AP31","v":0},{"$f":"ROUND((100*$S32*Cashflow!AQ31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AR31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AS31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AT31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AU31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AV31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AW31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AX31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AY31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!AZ31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!BA31)/(100+(100*$S32)),0)","v":0},{"$f":"ROUND((100*$S32*Cashflow!BB31)/(100+(100*$S32)),0)","v":0},null,null,"Chemicals and sundry crop costs",{"$f":"Cashflow!BF31","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BG31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BH31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BI31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BJ31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BK31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BL31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BM31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BN31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BO31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BP31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BQ31)/(100+(100*$AI32)),0)","v":0},{"$f":"ROUND((100*$AI32*Cashflow!BR31)/(100+(100*$AI32)),0)","v":0}]
[null,{"$f":"Cashflow!B31","v":"Chemicals and sundry crop costs"},{"$f":"Cashflow!C32","v":0},{"$f":"ROUND((100*$C33*Cashflow!D32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!F32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!H32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!M32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!O32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!Q32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!V32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!X32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!Z32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!AE32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!AG32)/(100+(100*$C33)),0)","v":0},{"$f":"ROUND((100*$C33*Cashflow!AI32)/(100+(100*$C33)),0)","v":0},null,null,"Chemicals and sundry crop costs",{"$f":"Cashflow!AP31","v":0},{"$f":"ROUND((100*$S33*Cashflow!AQ31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AR31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AS31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AT31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AU31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AV31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AW31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AX31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AY31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!AZ31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!BA31)/(100+(100*$S33)),0)","v":0},{"$f":"ROUND((100*$S33*Cashflow!BB31)/(100+(100*$S33)),0)","v":0},null,null,"Chemicals and sundry crop costs",{"$f":"Cashflow!BF31","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BG31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BH31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BI31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BJ31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BK31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BL31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BM31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BN31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BO31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BP31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BQ31)/(100+(100*$AI33)),0)","v":0},{"$f":"ROUND((100*$AI33*Cashflow!BR31)/(100+(100*$AI33)),0)","v":0}]
[null,{"$f":"Cashflow!B32","v":"Feedstuffs"},{"$f":"Cashflow!C33","v":0},{"$f":"ROUND((100*$C34*Cashflow!D33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!F33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!H33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!M33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!O33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!Q33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!V33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!X33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!Z33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!AE33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!AG33)/(100+(100*$C34)),0)","v":0},{"$f":"ROUND((100*$C34*Cashflow!AI33)/(100+(100*$C34)),0)","v":0},null,null,"Feedstuffs",{"$f":"Cashflow!AP32","v":0},{"$f":"ROUND((100*$S34*Cashflow!AQ32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AR32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AS32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AT32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AU32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AV32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AW32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AX32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AY32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!AZ32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!BA32)/(100+(100*$S34)),0)","v":0},{"$f":"ROUND((100*$S34*Cashflow!BB32)/(100+(100*$S34)),0)","v":0},null,null,"Feedstuffs",{"$f":"Cashflow!BF32","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BG32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BH32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BI32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BJ32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BK32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BL32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BM32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BN32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BO32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BP32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BQ32)/(100+(100*$AI34)),0)","v":0},{"$f":"ROUND((100*$AI34*Cashflow!BR32)/(100+(100*$AI34)),0)","v":0}]
[null,{"$f":"Cashflow!B33","v":"Purchased fodder"},{"$f":"Cashflow!C33","v":0},{"$f":"ROUND((100*$C35*Cashflow!D33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!F33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!H33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!M33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!O33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!Q33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!V33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!X33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!Z33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!AE33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!AG33)/(100+(100*$C35)),0)","v":0},{"$f":"ROUND((100*$C35*Cashflow!AI33)/(100+(100*$C35)),0)","v":0},null,null,"Purchased fodder",{"$f":"Cashflow!AP33","v":0},{"$f":"ROUND((100*$S35*Cashflow!AQ33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AR33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AS33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AT33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AU33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AV33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AW33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AX33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AY33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!AZ33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!BA33)/(100+(100*$S35)),0)","v":0},{"$f":"ROUND((100*$S35*Cashflow!BB33)/(100+(100*$S35)),0)","v":0},null,null,"Purchased fodder",{"$f":"Cashflow!BF33","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BG33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BH33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BI33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BJ33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BK33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BL33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BM33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BN33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BO33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BP33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BQ33)/(100+(100*$AI35)),0)","v":0},{"$f":"ROUND((100*$AI35*Cashflow!BR33)/(100+(100*$AI35)),0)","v":0}]
[null,{"$f":"Cashflow!B34","v":"Livestock"},{"$f":"Cashflow!C34","v":0},{"$f":"ROUND((100*$C36*Cashflow!D34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!F34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!H34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!M34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!O34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!Q34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!V34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!X34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!Z34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!AE34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!AG34)/(100+(100*$C36)),0)","v":0},{"$f":"ROUND((100*$C36*Cashflow!AI34)/(100+(100*$C36)),0)","v":0},null,null,"Livestock",{"$f":"Cashflow!AP34","v":0},{"$f":"ROUND((100*$S36*Cashflow!AQ34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AR34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AS34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AT34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AU34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AV34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AW34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AX34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AY34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!AZ34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!BA34)/(100+(100*$S36)),0)","v":0},{"$f":"ROUND((100*$S36*Cashflow!BB34)/(100+(100*$S36)),0)","v":0},null,null,"Livestock",{"$f":"Cashflow!BF34","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BG34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BH34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BI34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BJ34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BK34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BL34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BM34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BN34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BO34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BP34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BQ34)/(100+(100*$AI36)),0)","v":0},{"$f":"ROUND((100*$AI36*Cashflow!BR34)/(100+(100*$AI36)),0)","v":0}]
[null,{"$f":"Cashflow!B35","v":"Vet, medical and sundry livestock costs"},{"$f":"Cashflow!C35","v":0},{"$f":"ROUND((100*$C37*Cashflow!D35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!F35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!H35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!M35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!O35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!Q35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!V35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!X35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!Z35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!AE35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!AG35)/(100+(100*$C37)),0)","v":0},{"$f":"ROUND((100*$C37*Cashflow!AI35)/(100+(100*$C37)),0)","v":0},null,null,"Vet, medical and sundry livestock costs",{"$f":"Cashflow!AP35","v":0},{"$f":"ROUND((100*$S37*Cashflow!AQ35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AR35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AS35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AT35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AU35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AV35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AW35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AX35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AY35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!AZ35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!BA35)/(100+(100*$S37)),0)","v":0},{"$f":"ROUND((100*$S37*Cashflow!BB35)/(100+(100*$S37)),0)","v":0},null,null,"Vet, medical and sundry livestock costs",{"$f":"Cashflow!BF35","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BG35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BH35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BI35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BJ35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BK35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BL35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BM35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BN35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BO35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BP35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BQ35)/(100+(100*$AI37)),0)","v":0},{"$f":"ROUND((100*$AI37*Cashflow!BR35)/(100+(100*$AI37)),0)","v":0}]
[null,{"$f":"Cashflow!B36","v":0},{"$f":"Cashflow!C36","v":0},{"$f":"ROUND((100*$C38*Cashflow!D36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!F36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!H36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!M36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!O36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!Q36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!V36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!X36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!Z36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!AE36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!AG36)/(100+(100*$C38)),0)","v":0},{"$f":"ROUND((100*$C38*Cashflow!AI36)/(100+(100*$C38)),0)","v":0},null,null,0,{"$f":"Cashflow!AP36","v":0},{"$f":"ROUND((100*$S38*Cashflow!AQ36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AR36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AS36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AT36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AU36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AV36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AW36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AX36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AY36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!AZ36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!BA36)/(100+(100*$S38)),0)","v":0},{"$f":"ROUND((100*$S38*Cashflow!BB36)/(100+(100*$S38)),0)","v":0},null,null,0,{"$f":"Cashflow!BF36","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BG36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BH36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BI36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BJ36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BK36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BL36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BM36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BN36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BO36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BP36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BQ36)/(100+(100*$AI38)),0)","v":0},{"$f":"ROUND((100*$AI38*Cashflow!BR36)/(100+(100*$AI38)),0)","v":0}]
[null,{"$f":"Cashflow!B37","v":0},{"$f":"Cashflow!C37","v":0},{"$f":"ROUND((100*$C39*Cashflow!D37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!F37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!H37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!M37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!O37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!Q37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!V37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!X37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!Z37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!AE37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!AG37)/(100+(100*$C39)),0)","v":0},{"$f":"ROUND((100*$C39*Cashflow!AI37)/(100+(100*$C39)),0)","v":0},null,null,0,{"$f":"Cashflow!AP37","v":0},{"$f":"ROUND((100*$S39*Cashflow!AQ37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AR37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AS37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AT37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AU37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AV37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AW37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AX37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AY37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!AZ37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!BA37)/(100+(100*$S39)),0)","v":0},{"$f":"ROUND((100*$S39*Cashflow!BB37)/(100+(100*$S39)),0)","v":0},null,null,0,{"$f":"Cashflow!BF37","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BG37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BH37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BI37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BJ37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BK37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BL37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BM37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BN37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BO37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BP37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BQ37)/(100+(100*$AI39)),0)","v":0},{"$f":"ROUND((100*$AI39*Cashflow!BR37)/(100+(100*$AI39)),0)","v":0}]
[null,{"$f":"Cashflow!B38","v":"Power and machinery"},{"$f":"Cashflow!C38","v":0},{"$f":"ROUND((100*$C40*Cashflow!D38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!F38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!H38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!M38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!O38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!Q38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!V38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!X38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!Z38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!AE38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!AG38)/(100+(100*$C40)),0)","v":0},{"$f":"ROUND((100*$C40*Cashflow!AI38)/(100+(100*$C40)),0)","v":0},null,null,"Power and machinery",{"$f":"Cashflow!AP38","v":0},{"$f":"ROUND((100*$S40*Cashflow!AQ38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AR38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AS38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AT38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AU38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AV38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AW38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AX38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AY38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!AZ38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!BA38)/(100+(100*$S40)),0)","v":0},{"$f":"ROUND((100*$S40*Cashflow!BB38)/(100+(100*$S40)),0)","v":0},null,null,"Power and machinery",{"$f":"Cashflow!BF38","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BG38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BH38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BI38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BJ38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BK38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BL38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BM38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BN38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BO38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BP38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BQ38)/(100+(100*$AI40)),0)","v":0},{"$f":"ROUND((100*$AI40*Cashflow!BR38)/(100+(100*$AI40)),0)","v":0}]
[null,{"$f":"Cashflow!B39","v":"Repairs and spares"},{"$f":"Cashflow!C39","v":0.2},{"$f":"ROUND((100*$C41*Cashflow!D39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!F39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!H39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!M39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!O39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!Q39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!V39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!X39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!Z39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!AE39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!AG39)/(100+(100*$C41)),0)","v":0},{"$f":"ROUND((100*$C41*Cashflow!AI39)/(100+(100*$C41)),0)","v":0},null,null,"Repairs and spares",{"$f":"Cashflow!AP39","v":0.2},{"$f":"ROUND((100*$S41*Cashflow!AQ39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AR39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AS39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AT39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AU39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AV39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AW39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AX39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AY39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!AZ39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!BA39)/(100+(100*$S41)),0)","v":0},{"$f":"ROUND((100*$S41*Cashflow!BB39)/(100+(100*$S41)),0)","v":0},null,null,"Repairs and spares",{"$f":"Cashflow!BF39","v":0.2},{"$f":"ROUND((100*$AI41*Cashflow!BG39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BH39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BI39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BJ39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BK39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BL39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BM39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BN39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BO39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BP39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BQ39)/(100+(100*$AI41)),0)","v":0},{"$f":"ROUND((100*$AI41*Cashflow!BR39)/(100+(100*$AI41)),0)","v":0}]
[null,{"$f":"Cashflow!B40","v":"Fuel and oil"},{"$f":"Cashflow!C40","v":0.2},{"$f":"ROUND((100*$C42*Cashflow!D40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!F40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!H40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!M40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!O40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!Q40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!V40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!X40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!Z40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!AE40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!AG40)/(100+(100*$C42)),0)","v":0},{"$f":"ROUND((100*$C42*Cashflow!AI40)/(100+(100*$C42)),0)","v":0},null,null,"Fuel and oil",{"$f":"Cashflow!AP40","v":0.2},{"$f":"ROUND((100*$S42*Cashflow!AQ40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AR40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AS40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AT40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AU40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AV40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AW40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AX40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AY40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!AZ40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!BA40)/(100+(100*$S42)),0)","v":0},{"$f":"ROUND((100*$S42*Cashflow!BB40)/(100+(100*$S42)),0)","v":0},null,null,"Fuel and oil",{"$f":"Cashflow!BF40","v":0.2},{"$f":"ROUND((100*$AI42*Cashflow!BG40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BH40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BI40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BJ40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BK40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BL40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BM40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BN40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BO40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BP40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BQ40)/(100+(100*$AI42)),0)","v":0},{"$f":"ROUND((100*$AI42*Cashflow!BR40)/(100+(100*$AI42)),0)","v":0}]
[null,{"$f":"Cashflow!B41","v":"Electricity"},{"$f":"Cashflow!C41","v":0.2},{"$f":"ROUND((100*$C43*Cashflow!D41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!F41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!H41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!M41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!O41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!Q41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!V41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!X41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!Z41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!AE41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!AG41)/(100+(100*$C43)),0)","v":0},{"$f":"ROUND((100*$C43*Cashflow!AI41)/(100+(100*$C43)),0)","v":0},null,null,"Electricity",{"$f":"Cashflow!AP41","v":0.2},{"$f":"ROUND((100*$S43*Cashflow!AQ41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AR41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AS41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AT41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AU41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AV41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AW41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AX41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AY41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!AZ41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!BA41)/(100+(100*$S43)),0)","v":0},{"$f":"ROUND((100*$S43*Cashflow!BB41)/(100+(100*$S43)),0)","v":0},null,null,"Electricity",{"$f":"Cashflow!BF41","v":0.2},{"$f":"ROUND((100*$AI43*Cashflow!BG41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BH41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BI41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BJ41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BK41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BL41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BM41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BN41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BO41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BP41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BQ41)/(100+(100*$AI43)),0)","v":0},{"$f":"ROUND((100*$AI43*Cashflow!BR41)/(100+(100*$AI43)),0)","v":0}]
[null,{"$f":"Cashflow!B42","v":"Vehicle tax and insurance"},{"$f":"Cashflow!C42","v":0.2},{"$f":"ROUND((100*$C44*Cashflow!D42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!F42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!H42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!M42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!O42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!Q42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!V42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!X42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!Z42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!AE42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!AG42)/(100+(100*$C44)),0)","v":0},{"$f":"ROUND((100*$C44*Cashflow!AI42)/(100+(100*$C44)),0)","v":0},null,null,"Vehicle tax and insurance",{"$f":"Cashflow!AP42","v":0.2},{"$f":"ROUND((100*$S44*Cashflow!AQ42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AR42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AS42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AT42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AU42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AV42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AW42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AX42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AY42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!AZ42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!BA42)/(100+(100*$S44)),0)","v":0},{"$f":"ROUND((100*$S44*Cashflow!BB42)/(100+(100*$S44)),0)","v":0},null,null,"Vehicle tax and insurance",{"$f":"Cashflow!BF42","v":0.2},{"$f":"ROUND((100*$AI44*Cashflow!BG42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BH42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BI42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BJ42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BK42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BL42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BM42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BN42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BO42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BP42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BQ42)/(100+(100*$AI44)),0)","v":0},{"$f":"ROUND((100*$AI44*Cashflow!BR42)/(100+(100*$AI44)),0)","v":0}]
[null,{"$f":"Cashflow!B43","v":"Contractors "},{"$f":"Cashflow!C43","v":0.2},{"$f":"ROUND((100*$C45*Cashflow!D43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!F43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!H43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!M43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!O43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!Q43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!V43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!X43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!Z43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!AE43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!AG43)/(100+(100*$C45)),0)","v":0},{"$f":"ROUND((100*$C45*Cashflow!AI43)/(100+(100*$C45)),0)","v":0},null,null,"Contractors ",{"$f":"Cashflow!AP43","v":0.2},{"$f":"ROUND((100*$S45*Cashflow!AQ43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AR43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AS43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AT43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AU43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AV43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AW43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AX43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AY43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!AZ43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!BA43)/(100+(100*$S45)),0)","v":0},{"$f":"ROUND((100*$S45*Cashflow!BB43)/(100+(100*$S45)),0)","v":0},null,null,"Contractors ",{"$f":"Cashflow!BF43","v":0.2},{"$f":"ROUND((100*$AI45*Cashflow!BG43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BH43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BI43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BJ43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BK43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BL43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BM43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BN43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BO43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BP43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BQ43)/(100+(100*$AI45)),0)","v":0},{"$f":"ROUND((100*$AI45*Cashflow!BR43)/(100+(100*$AI45)),0)","v":0}]
[null,{"$f":"Cashflow!B44","v":0},{"$f":"Cashflow!C44","v":0},{"$f":"ROUND((100*$C46*Cashflow!D44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!F44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!H44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!M44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!O44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!Q44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!V44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!X44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!Z44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!AE44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!AG44)/(100+(100*$C46)),0)","v":0},{"$f":"ROUND((100*$C46*Cashflow!AI44)/(100+(100*$C46)),0)","v":0},null,null,0,{"$f":"Cashflow!AP44","v":0},{"$f":"ROUND((100*$S46*Cashflow!AQ44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AR44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AS44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AT44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AU44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AV44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AW44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AX44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AY44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!AZ44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!BA44)/(100+(100*$S46)),0)","v":0},{"$f":"ROUND((100*$S46*Cashflow!BB44)/(100+(100*$S46)),0)","v":0},null,null,0,{"$f":"Cashflow!BF44","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BG44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BH44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BI44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BJ44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BK44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BL44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BM44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BN44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BO44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BP44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BQ44)/(100+(100*$AI46)),0)","v":0},{"$f":"ROUND((100*$AI46*Cashflow!BR44)/(100+(100*$AI46)),0)","v":0}]
[null,{"$f":"Cashflow!B45","v":"Sundry overheads"},{"$f":"Cashflow!C45","v":0},{"$f":"ROUND((100*$C47*Cashflow!D45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!F45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!H45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!M45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!O45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!Q45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!V45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!X45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!Z45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!AE45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!AG45)/(100+(100*$C47)),0)","v":0},{"$f":"ROUND((100*$C47*Cashflow!AI45)/(100+(100*$C47)),0)","v":0},null,null,"Sundry overheads",{"$f":"Cashflow!AP45","v":0},{"$f":"ROUND((100*$S47*Cashflow!AQ45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AR45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AS45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AT45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AU45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AV45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AW45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AX45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AY45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!AZ45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!BA45)/(100+(100*$S47)),0)","v":0},{"$f":"ROUND((100*$S47*Cashflow!BB45)/(100+(100*$S47)),0)","v":0},null,null,"Sundry overheads",{"$f":"Cashflow!BF45","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BG45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BH45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BI45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BJ45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BK45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BL45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BM45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BN45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BO45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BP45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BQ45)/(100+(100*$AI47)),0)","v":0},{"$f":"ROUND((100*$AI47*Cashflow!BR45)/(100+(100*$AI47)),0)","v":0}]
[null,{"$f":"Cashflow!B46","v":"Water"},{"$f":"Cashflow!C46","v":0},{"$f":"ROUND((100*$C48*Cashflow!D46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!F46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!H46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!M46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!O46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!Q46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!V46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!X46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!Z46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!AE46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!AG46)/(100+(100*$C48)),0)","v":0},{"$f":"ROUND((100*$C48*Cashflow!AI46)/(100+(100*$C48)),0)","v":0},null,null,"Water",{"$f":"Cashflow!AP46","v":0},{"$f":"ROUND((100*$S48*Cashflow!AQ46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AR46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AS46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AT46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AU46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AV46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AW46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AX46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AY46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!AZ46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!BA46)/(100+(100*$S48)),0)","v":0},{"$f":"ROUND((100*$S48*Cashflow!BB46)/(100+(100*$S48)),0)","v":0},null,null,"Water",{"$f":"Cashflow!BF46","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BG46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BH46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BI46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BJ46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BK46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BL46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BM46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BN46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BO46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BP46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BQ46)/(100+(100*$AI48)),0)","v":0},{"$f":"ROUND((100*$AI48*Cashflow!BR46)/(100+(100*$AI48)),0)","v":0}]
[null,{"$f":"Cashflow!B47","v":"General insurance"},{"$f":"Cashflow!C47","v":0},{"$f":"ROUND((100*$C49*Cashflow!D47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!F47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!H47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!M47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!O47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!Q47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!V47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!X47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!Z47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!AE47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!AG47)/(100+(100*$C49)),0)","v":0},{"$f":"ROUND((100*$C49*Cashflow!AI47)/(100+(100*$C49)),0)","v":0},null,null,"General insurance",{"$f":"Cashflow!AP47","v":0},{"$f":"ROUND((100*$S49*Cashflow!AQ47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AR47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AS47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AT47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AU47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AV47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AW47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AX47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AY47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!AZ47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!BA47)/(100+(100*$S49)),0)","v":0},{"$f":"ROUND((100*$S49*Cashflow!BB47)/(100+(100*$S49)),0)","v":0},null,null,"General insurance",{"$f":"Cashflow!BF47","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BG47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BH47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BI47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BJ47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BK47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BL47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BM47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BN47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BO47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BP47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BQ47)/(100+(100*$AI49)),0)","v":0},{"$f":"ROUND((100*$AI49*Cashflow!BR47)/(100+(100*$AI49)),0)","v":0}]
[null,{"$f":"Cashflow!B48","v":"Office costs"},{"$f":"Cashflow!C48","v":0.2},{"$f":"ROUND((100*$C50*Cashflow!D48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!F48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!H48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!M48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!O48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!Q48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!V48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!X48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!Z48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!AE48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!AG48)/(100+(100*$C50)),0)","v":0},{"$f":"ROUND((100*$C50*Cashflow!AI48)/(100+(100*$C50)),0)","v":0},null,null,"Office costs",{"$f":"Cashflow!AP48","v":0.2},{"$f":"ROUND((100*$S50*Cashflow!AQ48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AR48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AS48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AT48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AU48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AV48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AW48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AX48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AY48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!AZ48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!BA48)/(100+(100*$S50)),0)","v":0},{"$f":"ROUND((100*$S50*Cashflow!BB48)/(100+(100*$S50)),0)","v":0},null,null,"Office costs",{"$f":"Cashflow!BF48","v":0.2},{"$f":"ROUND((100*$AI50*Cashflow!BG48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BH48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BI48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BJ48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BK48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BL48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BM48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BN48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BO48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BP48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BQ48)/(100+(100*$AI50)),0)","v":0},{"$f":"ROUND((100*$AI50*Cashflow!BR48)/(100+(100*$AI50)),0)","v":0}]
[null,{"$f":"Cashflow!B49","v":"Miscellaneous costs"},{"$f":"Cashflow!C49","v":0.2},{"$f":"ROUND((100*$C51*Cashflow!D49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!F49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!H49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!M49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!O49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!Q49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!V49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!X49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!Z49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!AE49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!AG49)/(100+(100*$C51)),0)","v":0},{"$f":"ROUND((100*$C51*Cashflow!AI49)/(100+(100*$C51)),0)","v":0},null,null,"Miscellaneous costs",{"$f":"Cashflow!AP49","v":0.2},{"$f":"ROUND((100*$S51*Cashflow!AQ49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AR49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AS49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AT49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AU49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AV49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AW49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AX49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AY49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!AZ49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!BA49)/(100+(100*$S51)),0)","v":0},{"$f":"ROUND((100*$S51*Cashflow!BB49)/(100+(100*$S51)),0)","v":0},null,null,"Miscellaneous costs",{"$f":"Cashflow!BF49","v":0.2},{"$f":"ROUND((100*$AI51*Cashflow!BG49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BH49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BI49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BJ49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BK49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BL49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BM49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BN49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BO49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BP49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BQ49)/(100+(100*$AI51)),0)","v":0},{"$f":"ROUND((100*$AI51*Cashflow!BR49)/(100+(100*$AI51)),0)","v":0}]
[null,{"$f":"Cashflow!B50","v":"Council tax"},{"$f":"Cashflow!C50","v":0},{"$f":"ROUND((100*$C52*Cashflow!D50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!F50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!H50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!M50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!O50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!Q50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!V50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!X50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!Z50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!AE50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!AG50)/(100+(100*$C52)),0)","v":0},{"$f":"ROUND((100*$C52*Cashflow!AI50)/(100+(100*$C52)),0)","v":0},null,null,"Council tax",{"$f":"Cashflow!AP50","v":0},{"$f":"ROUND((100*$S52*Cashflow!AQ50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AR50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AS50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AT50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AU50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AV50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AW50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AX50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AY50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!AZ50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!BA50)/(100+(100*$S52)),0)","v":0},{"$f":"ROUND((100*$S52*Cashflow!BB50)/(100+(100*$S52)),0)","v":0},null,null,"Council tax",{"$f":"Cashflow!BF50","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BG50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BH50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BI50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BJ50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BK50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BL50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BM50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BN50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BO50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BP50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BQ50)/(100+(100*$AI52)),0)","v":0},{"$f":"ROUND((100*$AI52*Cashflow!BR50)/(100+(100*$AI52)),0)","v":0}]
[null,{"$f":"Cashflow!B51","v":"Advice and professional fees"},{"$f":"Cashflow!C51","v":0.2},{"$f":"ROUND((100*$C53*Cashflow!D51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!F51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!H51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!M51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!O51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!Q51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!V51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!X51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!Z51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!AE51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!AG51)/(100+(100*$C53)),0)","v":0},{"$f":"ROUND((100*$C53*Cashflow!AI51)/(100+(100*$C53)),0)","v":0},null,null,"Advice and professional fees",{"$f":"Cashflow!AP51","v":0.2},{"$f":"ROUND((100*$S53*Cashflow!AQ51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AR51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AS51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AT51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AU51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AV51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AW51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AX51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AY51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!AZ51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!BA51)/(100+(100*$S53)),0)","v":0},{"$f":"ROUND((100*$S53*Cashflow!BB51)/(100+(100*$S53)),0)","v":0},null,null,"Advice and professional fees",{"$f":"Cashflow!BF51","v":0.2},{"$f":"ROUND((100*$AI53*Cashflow!BG51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BH51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BI51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BJ51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BK51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BL51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BM51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BN51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BO51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BP51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BQ51)/(100+(100*$AI53)),0)","v":0},{"$f":"ROUND((100*$AI53*Cashflow!BR51)/(100+(100*$AI53)),0)","v":0}]
[null,{"$f":"Cashflow!B52","v":"Repairs/maintenance on land and buildings"},{"$f":"Cashflow!C52","v":0.2},{"$f":"ROUND((100*$C54*Cashflow!D52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!F52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!H52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!M52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!O52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!Q52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!V52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!X52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!Z52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!AE52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!AG52)/(100+(100*$C54)),0)","v":0},{"$f":"ROUND((100*$C54*Cashflow!AI52)/(100+(100*$C54)),0)","v":0},null,null,"Repairs/maintenance on land and buildings",{"$f":"Cashflow!AP52","v":0.2},{"$f":"ROUND((100*$S54*Cashflow!AQ52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AR52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AS52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AT52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AU52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AV52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AW52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AX52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AY52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!AZ52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!BA52)/(100+(100*$S54)),0)","v":0},{"$f":"ROUND((100*$S54*Cashflow!BB52)/(100+(100*$S54)),0)","v":0},null,null,"Repairs/maintenance on land and buildings",{"$f":"Cashflow!BF52","v":0.2},{"$f":"ROUND((100*$AI54*Cashflow!BG52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BH52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BI52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BJ52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BK52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BL52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BM52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BN52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BO52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BP52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BQ52)/(100+(100*$AI54)),0)","v":0},{"$f":"ROUND((100*$AI54*Cashflow!BR52)/(100+(100*$AI54)),0)","v":0}]
[null,{"$f":"Cashflow!B53","v":0},{"$f":"Cashflow!C53","v":0},{"$f":"ROUND((100*$C55*Cashflow!D53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!F53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!H53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!M53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!O53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!Q53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!V53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!X53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!Z53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!AE53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!AG53)/(100+(100*$C55)),0)","v":0},{"$f":"ROUND((100*$C55*Cashflow!AI53)/(100+(100*$C55)),0)","v":0},null,null,0,{"$f":"Cashflow!AP53","v":0},{"$f":"ROUND((100*$S55*Cashflow!AQ53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AR53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AS53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AT53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AU53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AV53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AW53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AX53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AY53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!AZ53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!BA53)/(100+(100*$S55)),0)","v":0},{"$f":"ROUND((100*$S55*Cashflow!BB53)/(100+(100*$S55)),0)","v":0},null,null,0,{"$f":"Cashflow!BF53","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BG53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BH53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BI53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BJ53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BK53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BL53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BM53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BN53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BO53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BP53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BQ53)/(100+(100*$AI55)),0)","v":0},{"$f":"ROUND((100*$AI55*Cashflow!BR53)/(100+(100*$AI55)),0)","v":0}]
[null,{"$f":"Cashflow!B54","v":"Rent "},{"$f":"Cashflow!C54","v":0},{"$f":"ROUND((100*$C56*Cashflow!D54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!F54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!H54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!M54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!O54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!Q54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!V54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!X54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!Z54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!AE54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!AG54)/(100+(100*$C56)),0)","v":0},{"$f":"ROUND((100*$C56*Cashflow!AI54)/(100+(100*$C56)),0)","v":0},null,null,"Rent ",{"$f":"Cashflow!AP54","v":0},{"$f":"ROUND((100*$S56*Cashflow!AQ54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AR54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AS54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AT54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AU54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AV54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AW54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AX54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AY54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!AZ54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!BA54)/(100+(100*$S56)),0)","v":0},{"$f":"ROUND((100*$S56*Cashflow!BB54)/(100+(100*$S56)),0)","v":0},null,null,"Rent ",{"$f":"Cashflow!BF54","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BG54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BH54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BI54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BJ54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BK54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BL54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BM54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BN54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BO54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BP54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BQ54)/(100+(100*$AI56)),0)","v":0},{"$f":"ROUND((100*$AI56*Cashflow!BR54)/(100+(100*$AI56)),0)","v":0}]
[null,{"$f":"Cashflow!B55","v":"Paid labour"},{"$f":"Cashflow!C55","v":0},{"$f":"ROUND((100*$C57*Cashflow!D55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!F55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!H55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!M55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!O55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!Q55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!V55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!X55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!Z55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!AE55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!AG55)/(100+(100*$C57)),0)","v":0},{"$f":"ROUND((100*$C57*Cashflow!AI55)/(100+(100*$C57)),0)","v":0},null,null,"Paid labour",{"$f":"Cashflow!AP55","v":0},{"$f":"ROUND((100*$S57*Cashflow!AQ55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AR55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AS55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AT55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AU55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AV55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AW55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AX55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AY55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!AZ55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!BA55)/(100+(100*$S57)),0)","v":0},{"$f":"ROUND((100*$S57*Cashflow!BB55)/(100+(100*$S57)),0)","v":0},null,null,"Paid labour",{"$f":"Cashflow!BF55","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BG55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BH55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BI55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BJ55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BK55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BL55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BM55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BN55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BO55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BP55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BQ55)/(100+(100*$AI57)),0)","v":0},{"$f":"ROUND((100*$AI57*Cashflow!BR55)/(100+(100*$AI57)),0)","v":0}]
[null,{"$f":"Cashflow!B56","v":"Other cash purchase"},{"$f":"Cashflow!C56","v":0.2},{"$f":"ROUND((100*$C58*Cashflow!D56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!F56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!H56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!M56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!O56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!Q56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!V56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!X56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!Z56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!AE56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!AG56)/(100+(100*$C58)),0)","v":0},{"$f":"ROUND((100*$C58*Cashflow!AI56)/(100+(100*$C58)),0)","v":0},null,null,"Other cash purchase",{"$f":"Cashflow!AP56","v":0.2},{"$f":"ROUND((100*$S58*Cashflow!AQ56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AR56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AS56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AT56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AU56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AV56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AW56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AX56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AY56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!AZ56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!BA56)/(100+(100*$S58)),0)","v":0},{"$f":"ROUND((100*$S58*Cashflow!BB56)/(100+(100*$S58)),0)","v":0},null,null,"Other cash purchase",{"$f":"Cashflow!BF56","v":0.2},{"$f":"ROUND((100*$AI58*Cashflow!BG56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BH56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BI56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BJ56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BK56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BL56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BM56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BN56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BO56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BP56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BQ56)/(100+(100*$AI58)),0)","v":0},{"$f":"ROUND((100*$AI58*Cashflow!BR56)/(100+(100*$AI58)),0)","v":0}]
[null,{"$f":"Cashflow!B57","v":"Bank charges"},{"$f":"Cashflow!C57","v":0},{"$f":"ROUND((100*$C59*Cashflow!D57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!F57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!H57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!M57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!O57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!Q57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!V57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!X57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!Z57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!AE57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!AG57)/(100+(100*$C59)),0)","v":0},{"$f":"ROUND((100*$C59*Cashflow!AI57)/(100+(100*$C59)),0)","v":0},null,null,"Bank charges",{"$f":"Cashflow!AP57","v":0},{"$f":"ROUND((100*$S59*Cashflow!AQ57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AR57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AS57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AT57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AU57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AV57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AW57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AX57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AY57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!AZ57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!BA57)/(100+(100*$S59)),0)","v":0},{"$f":"ROUND((100*$S59*Cashflow!BB57)/(100+(100*$S59)),0)","v":0},null,null,"Bank charges",{"$f":"Cashflow!BF57","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BG57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BH57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BI57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BJ57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BK57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BL57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BM57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BN57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BO57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BP57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BQ57)/(100+(100*$AI59)),0)","v":0},{"$f":"ROUND((100*$AI59*Cashflow!BR57)/(100+(100*$AI59)),0)","v":0}]
[null,{"$f":"Cashflow!B58","v":0},{"$f":"Cashflow!C58","v":0},{"$f":"ROUND((100*$C60*Cashflow!D58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!F58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!H58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!M58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!O58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!Q58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!V58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!X58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!Z58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!AE58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!AG58)/(100+(100*$C60)),0)","v":0},{"$f":"ROUND((100*$C60*Cashflow!AI58)/(100+(100*$C60)),0)","v":0},null,null,{"$f":"$B60","v":0},{"$f":"Cashflow!AP58","v":0},{"$f":"ROUND((100*$S60*Cashflow!AQ58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AR58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AS58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AT58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AU58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AV58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AW58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AX58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AY58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!AZ58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!BA58)/(100+(100*$S60)),0)","v":0},{"$f":"ROUND((100*$S60*Cashflow!BB58)/(100+(100*$S60)),0)","v":0},null,null,{"$f":"$B60","v":0},{"$f":"Cashflow!BF58","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BG58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BH58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BI58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BJ58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BK58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BL58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BM58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BN58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BO58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BP58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BQ58)/(100+(100*$AI60)),0)","v":0},{"$f":"ROUND((100*$AI60*Cashflow!BR58)/(100+(100*$AI60)),0)","v":0}]
[null,{"$f":"Cashflow!B59","v":0},{"$f":"Cashflow!C59","v":0},{"$f":"ROUND((100*$C61*Cashflow!D59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!F59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!H59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!M59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!O59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!Q59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!V59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!X59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!Z59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!AE59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!AG59)/(100+(100*$C61)),0)","v":0},{"$f":"ROUND((100*$C61*Cashflow!AI59)/(100+(100*$C61)),0)","v":0},null,null,null,{"$f":"Cashflow!AP59","v":0},{"$f":"ROUND((100*$S61*Cashflow!AQ59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AR59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AS59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AT59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AU59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AV59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AW59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AX59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AY59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!AZ59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!BA59)/(100+(100*$S61)),0)","v":0},{"$f":"ROUND((100*$S61*Cashflow!BB59)/(100+(100*$S61)),0)","v":0},null,null,null,{"$f":"Cashflow!BF59","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BG59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BH59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BI59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BJ59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BK59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BL59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BM59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BN59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BO59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BP59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BQ59)/(100+(100*$AI61)),0)","v":0},{"$f":"ROUND((100*$AI61*Cashflow!BR59)/(100+(100*$AI61)),0)","v":0}]
[null,{"$f":"Cashflow!B60","v":"Drawings"},{"$f":"Cashflow!C60","v":0},{"$f":"ROUND((100*$C62*Cashflow!D60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!F60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!H60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!M60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!O60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!Q60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!V60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!X60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!Z60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!AE60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!AG60)/(100+(100*$C62)),0)","v":0},{"$f":"ROUND((100*$C62*Cashflow!AI60)/(100+(100*$C62)),0)","v":0},null,null,"Drawings",{"$f":"Cashflow!AP60","v":0},{"$f":"ROUND((100*$S62*Cashflow!AQ60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AR60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AS60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AT60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AU60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AV60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AW60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AX60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AY60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!AZ60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!BA60)/(100+(100*$S62)),0)","v":0},{"$f":"ROUND((100*$S62*Cashflow!BB60)/(100+(100*$S62)),0)","v":0},null,null,"Drawings",{"$f":"Cashflow!BF60","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BG60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BH60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BI60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BJ60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BK60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BL60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BM60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BN60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BO60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BP60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BQ60)/(100+(100*$AI62)),0)","v":0},{"$f":"ROUND((100*$AI62*Cashflow!BR60)/(100+(100*$AI62)),0)","v":0}]
[null,{"$f":"Cashflow!B61","v":"Tax"},{"$f":"Cashflow!C61","v":0},{"$f":"ROUND((100*$C63*Cashflow!D61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!F61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!H61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!M61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!O61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!Q61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!V61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!X61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!Z61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!AE61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!AG61)/(100+(100*$C63)),0)","v":0},{"$f":"ROUND((100*$C63*Cashflow!AI61)/(100+(100*$C63)),0)","v":0},null,null,"Tax",{"$f":"Cashflow!AP61","v":0},{"$f":"ROUND((100*$S63*Cashflow!AQ61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AR61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AS61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AT61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AU61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AV61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AW61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AX61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AY61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!AZ61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!BA61)/(100+(100*$S63)),0)","v":0},{"$f":"ROUND((100*$S63*Cashflow!BB61)/(100+(100*$S63)),0)","v":0},null,null,"Tax",{"$f":"Cashflow!BF61","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BG61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BH61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BI61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BJ61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BK61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BL61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BM61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BN61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BO61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BP61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BQ61)/(100+(100*$AI63)),0)","v":0},{"$f":"ROUND((100*$AI63*Cashflow!BR61)/(100+(100*$AI63)),0)","v":0}]
[null,{"$f":"Cashflow!B62","v":"Asset purchases"},{"$f":"Cashflow!C62","v":0},{"$f":"ROUND((100*$C64*Cashflow!D62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!F62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!H62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!M62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!O62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!Q62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!V62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!X62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!Z62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!AE62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!AG62)/(100+(100*$C64)),0)","v":0},{"$f":"ROUND((100*$C64*Cashflow!AI62)/(100+(100*$C64)),0)","v":0},null,null,"Asset purchases",{"$f":"Cashflow!AP62","v":0},{"$f":"ROUND((100*$S64*Cashflow!AQ62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AR62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AS62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AT62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AU62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AV62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AW62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AX62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AY62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!AZ62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!BA62)/(100+(100*$S64)),0)","v":0},{"$f":"ROUND((100*$S64*Cashflow!BB62)/(100+(100*$S64)),0)","v":0},null,null,"Asset purchases",{"$f":"Cashflow!BF62","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BG62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BH62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BI62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BJ62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BK62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BL62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BM62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BN62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BO62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BP62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BQ62)/(100+(100*$AI64)),0)","v":0},{"$f":"ROUND((100*$AI64*Cashflow!BR62)/(100+(100*$AI64)),0)","v":0}]
[null,{"$f":"Cashflow!B63","v":"Capital repayments"},{"$f":"Cashflow!C63","v":0},{"$f":"ROUND((100*$C65*Cashflow!D63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!F63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!H63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!M63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!O63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!Q63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!V63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!X63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!Z63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!AE63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!AG63)/(100+(100*$C65)),0)","v":0},{"$f":"ROUND((100*$C65*Cashflow!AI63)/(100+(100*$C65)),0)","v":0},null,null,"Capital repayments",{"$f":"Cashflow!AP63","v":0},{"$f":"ROUND((100*$S65*Cashflow!AQ63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AR63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AS63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AT63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AU63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AV63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AW63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AX63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AY63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!AZ63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!BA63)/(100+(100*$S65)),0)","v":0},{"$f":"ROUND((100*$S65*Cashflow!BB63)/(100+(100*$S65)),0)","v":0},null,null,"Capital repayments",{"$f":"Cashflow!BF63","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BG63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BH63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BI63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BJ63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BK63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BL63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BM63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BN63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BO63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BP63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BQ63)/(100+(100*$AI65)),0)","v":0},{"$f":"ROUND((100*$AI65*Cashflow!BR63)/(100+(100*$AI65)),0)","v":0}]
[null,{"$f":"Cashflow!B64","v":"Interest payments"},{"$f":"Cashflow!C64","v":0},{"$f":"ROUND((100*$C66*Cashflow!D64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!F64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!H64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!M64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!O64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!Q64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!V64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!X64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!Z64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!AE64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!AG64)/(100+(100*$C66)),0)","v":0},{"$f":"ROUND((100*$C66*Cashflow!AI64)/(100+(100*$C66)),0)","v":0},null,null,"Interest payments",{"$f":"Cashflow!AP64","v":0},{"$f":"ROUND((100*$S66*Cashflow!AQ64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AR64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AS64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AT64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AU64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AV64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AW64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AX64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AY64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!AZ64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!BA64)/(100+(100*$S66)),0)","v":0},{"$f":"ROUND((100*$S66*Cashflow!BB64)/(100+(100*$S66)),0)","v":0},null,null,"Interest payments",{"$f":"Cashflow!BF64","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BG64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BH64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BI64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BJ64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BK64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BL64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BM64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BN64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BO64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BP64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BQ64)/(100+(100*$AI66)),0)","v":0},{"$f":"ROUND((100*$AI66*Cashflow!BR64)/(100+(100*$AI66)),0)","v":0}]
[null,{"$f":"Cashflow!B65","v":0},{"$f":"Cashflow!C65","v":0},{"$nulls":14},0,{"$f":"Cashflow!AP65","v":0},{"$nulls":14},0,{"$f":"Cashflow!BF65","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BG65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BH65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BI65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BJ65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BK65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BL65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BM65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BN65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BO65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BP65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BQ65)/(100+(100*$AI67)),0)","v":0},{"$f":"ROUND((100*$AI67*Cashflow!BR65)/(100+(100*$AI67)),0)","v":0}]
[null,{"$f":"Cashflow!B66","v":"Total outflows"},{"$f":"Cashflow!C66","v":0},{"$f":"SUM(D31:D66)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,"Total outflows",null,{"$f":"SUM(T31:T66)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,"Total outflows",null,{"$f":"SUM(AJ31:AJ66)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Movement",null,{"$f":"D27-D68","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,"Movement",null,{"$f":"T27-T68","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,"Movement",null,{"$f":"AJ27-AJ68","v":0},0,0,0,0,0,0,0,0,0,0,0]